<form action="<?php echo base_url()?>staff/loadInterviewerPass" name="formInsertCV" method="POST">
<?php

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
$bar="List Interviewer Passed";
        echo '<table class="tablebg" cellspacing="1" align="right" border="0" width="900px">';
        $sql="select distinct PositionInterview from Interview";
        $query2=$this->db->query($sql);
        echo '<tr>
            <td class=row10 align=left colspan=2>Select PositionInterview to view Interview Passed</td>
            <td class=row12 align=left colspan=3><select name=txtPositionInterview>';
        
        foreach($query2->result() as $item){
                                     if($item->PositionInterview == $PositionInterview)
                                     echo "<option selected>$item->PositionInterview</option>";
                                     else echo "<option>$item->PositionInterview</option>";
                                   }
        echo '</select><input type=submit name=submit id=submit value=search><td></td>';
            
        echo '<br><br><br>';
        echo '<tr><td colspan=5 align=right class=bar>'.$bar.'</td></tr>';
        //echo '<tr><td colspan=5 align=right class=pagination>'.$pagination.'</td></tr>';
        echo '
              <th>CV ID</th>
              <th>FullName</th>
              <th>FirstName</th>
              <th>LastName</th>
              <th>Action</th>';
        
        foreach($query->result() as $row){
            //$images='<img src="'.base_url().'application/templates/images/'.$row->staff_avarta.'" width=100 height=70>';
            //$details = anchor("user/loadUpdateForm/$row->Staff_ID",$images);
            echo "<tr>
                        <td class=\"row10\">$row->CV_ID</td>";
            $sql="select * from CV where CV_ID=$row->CV_ID";
            $query1=$this->db->query($sql);
            foreach($query1->result() as $row1)
            {
                        echo "<td class=\"row12\">$row1->FullName</td>
                        <td class=\"row10\">$row1->FirstName</td>
                        <td class=\"row12\">$row1->LastName</td>";
            }
            
            /*$titleUpdate = '<img src ="'.base_url().'templates/images/icons/edit.gif" title="Click here to modify"/>';
            $titleDelete = '<img src ="'.base_url().'templates/images/icons/delete.png" title="Click here to delete"/>';
            //$titleActive = '<img src ="'.base_url().'application/templates/images/icons/active.jpg" title="Click here to active"/>';
            $titleView = '<img src ="'.base_url().'templates/images/icons/view.gif" height=25 title="Click here to view "/>';
            $titleInsertFamily = '<img src ="'.base_url().'templates/images/icons/insert_family.jpeg" width=40 height=25 title="Click here to insert family"/>';
            $update = anchor("staff/loadStaffUpdateForm/$row->Staff_ID",$titleUpdate);
            $delete = anchor("staff/deleteStaff/$row->Staff_ID",$titleDelete);
            //$active = anchor("user/loadConfirmForm/$row->Staff_ID",$titleActive);
            $view_staff=anchor("staff/viewInformationStaff/$row->Staff_ID",$titleView);
            $insert_family=anchor("staff/loadFormInsertFamily/$row->Staff_ID",$titleInsertFamily);*/
            $titleInsertInterviewPass = '<img src ="'.base_url().'templates/images/icons/addstaff.jpeg" width=60 height=40 title="Click here to insert this person"/>';
            $insert = anchor("staff/loadFormInsertStaff/$row->CV_ID",$titleInsertInterviewPass);
            echo "<td class=\"row12\" align=\"center\">$insert</td></tr>";
            }?>
            <tr>
        <td class="row1" align="center" colspan="4">
            <?php $titleback = '<img src ="'.base_url().'templates/images/icons/back.jpg" width=40 height=25 title="Back"/>';
            $back = anchor("staff/index",$titleback);
            echo $back;?>
        </td>
    </tr>
    <?php
        echo '</table>';
?>
</form>
